<?php
  require_once('scripts/restrict_access.php');
?> 
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<!--

Design by Free CSS Templates
http://www.freecsstemplates.org
Released for free under a Creative Commons Attribution 2.5 License

Title      : Complimentary
Version    : 1.0
Released   : 20080409
Description: A two-column, fixed-width and lightweight template ideal for 1024x768 resolutions. Suitable for blogs and small websites.

-->
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>Complimentary by Free Css Templates</title>
<meta name="keywords" content="" />
<meta name="description" content="" />
<link href="CSS/ComplementaryDefault.css" rel="stylesheet" type="text/css" media="screen" />
</head>
<body>
<!-- start header -->
<div id="header">
<div id="logo">
    <h1><a href="#">Find-it</a> </h1>
  </div>
  <div id="menu">
    <div id="buttons">
      <ul>
        
        <li>
        <a href="DBList.php"> Catalogs </a>
        </li>
        
        <li><a href="UserList.php">Users </a></li>
        <li><a href="Index.php?logout">Logout </a></li>
      </ul>
    </div>
  </div>
</div>
<!-- end header -->
<!-- start page -->
<div id="page"> 
  <!-- start content -->
  <div id="content">
    <div class="post">
      <p><br />
      </p>
        <h1 class="title">&nbsp;</h1>
      <h1 class="title">Your Reports</h1>

<?php
		$sql='SELECT itemId,itemName,keywords,checkedOut,containerId FROM `items` WHERE `accountId`= ? ORDER BY `containerId`';
		$result = $dbRead->fetchAll($sql,$_SESSION['accountId']);
		$size_of_result = sizeof($result);
		
?>

<?php
	$SQL = 'SELECT dbName,dbID,dbDescription FROM `databases` WHERE `accountId`= ? ORDER BY dbName';
  $RESULT = $dbRead->fetchAll($SQL,$_SESSION['accountId']);
  $size_of_RESULT = sizeof($RESULT);
?>

<table width="100%" border="0">
        <tr>
          <td ><div align="center"><a href="ItemsByName.php?dbId=<?php echo $RESULT[$i]['dbID'];?>&amp;name=<?php echo urlencode($RESULT[$i]['dbName']);?>">List Items by Name</a></div></td>
          <td><div align="center"><a href="ItemsByContainer.php">List Items by Container</a></div></td>
          <td "><div align="center"><a href="ItemsByKeyword.php">List Items by Keyword</a></div></td>
          </tr>
      </table>
      <!-- The bottomSpace div is for reserving space at the bottom for the footer -->
        <div class="bottomSpace">
          <p><br /><br />
          </p>
        </div>
    </div>
  </div>
  <!-- end content --> 
  <!-- start sidebar --><!-- end sidebar -->
  <div style="clear: both;">&nbsp;</div>
</div>
<!-- end page -->
<!-- start footer -->
<div id="footer">
  <p id="legal">(c) 2012 Find-It. Design by <a href="http://www.freecsstemplates.org/">Free CSS Templates</a>.<br />
	</p>
</div>
<!-- end footer -->
</body>
</html>
